UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nJ0a+B/sBedS+UavV3Hr9yUj1aOfwlMWwJHagAI5h2k='
WHERE
key_id = '9ab42235d725e0b0c80a828a031e7e42c4619e6bda02d880a5dcdff3a3f84ed0'
AND (
token = 'nJ0a+B/sBedS+UavV3Hr9yUj1aOfwlMWwJHagAI5h2k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)