UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sUS/A/3bktZeoWrLb3tPlLGxS3W2q17OC/jRJrbcWjs='
WHERE
key_id = '7e9697aa149743c2dade860a3ee861d540dec6ccc042a4f5de9fbd81fc87b080'
AND (
token = 'sUS/A/3bktZeoWrLb3tPlLGxS3W2q17OC/jRJrbcWjs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)