UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mi9S/MtTMWNi6dtrRetJMeESWLhdMfQvnU6FA3kB8L0='
WHERE
key_id = 'd957145746abf4d8d4478895acb67c1c84ff7d4a59000f11b1f1067fd0b27c39'
AND (
token = 'mi9S/MtTMWNi6dtrRetJMeESWLhdMfQvnU6FA3kB8L0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)