UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qghsyuYc1AUYbixerKAiKAhTMtAeoi/3kx5u2W8KNsI='
WHERE
key_id = '4dbc688ec02467f50b1cf18b25cf99cd0b2a44c9e474761decfb1f9e0f43c121'
AND (
token = 'qghsyuYc1AUYbixerKAiKAhTMtAeoi/3kx5u2W8KNsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)