UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mHrMOB+27hW/6HYfUD8/XLBlL+97eIM30bZZKCGLZto='
WHERE
key_id = 'c7c7891f62d19b954aec5b1a70ef65ba207ce6000a12ac73d160e4df30f0842e'
AND (
token = 'mHrMOB+27hW/6HYfUD8/XLBlL+97eIM30bZZKCGLZto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)