UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5QO6YqIcGz5OVOC7ZQUOBphTQq3w7Mz5M4qKaOvsHoM='
WHERE
key_id = '557d809fd3d4d398a79c643b472a69426cf4aa7e736bff9c120a9669554e279b'
AND (
token = '5QO6YqIcGz5OVOC7ZQUOBphTQq3w7Mz5M4qKaOvsHoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)