UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'smNifoEebRR1ZfVCUCBCKUWz5q2l6CpLJBwixsQeBzc='
WHERE
key_id = '7aee79a0271abf4d7dcbe7233d4c76f0c20294eb32934110dbe74d2b3789cbbc'
AND (
token = 'smNifoEebRR1ZfVCUCBCKUWz5q2l6CpLJBwixsQeBzc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)