UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jJZG8UsnhwxX0nrCl5EXGh8EMORcI5CSXlnl7osWdIQ='
WHERE
key_id = '8e6e8c618ea1d7f480d212fe8ebb15e50883f8cf34cff4e3180ad72c88f9ff38'
AND (
token = 'jJZG8UsnhwxX0nrCl5EXGh8EMORcI5CSXlnl7osWdIQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)