UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tl9VU7sAchgMU44e8KSTG8k+lZFXRHabcdt0TMx1wZg='
WHERE
key_id = '0dde7c213ed2dcf5761d0c9e18a53c8be0e9d21273ea28ccd2e5fad19e33ac28'
AND (
token = 'tl9VU7sAchgMU44e8KSTG8k+lZFXRHabcdt0TMx1wZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)