UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mn1RIIFnmFwl5T23qjpHybOi2N0c5OQSmO6/FiaAzvc='
WHERE
key_id = 'c795f287c2f21f54b371116041c9b91174a78f95d6d0772f05fc5828db6429b7'
AND (
token = 'mn1RIIFnmFwl5T23qjpHybOi2N0c5OQSmO6/FiaAzvc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)