UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fQOw7O3ZuKzypvtZYoZ2E+7jL/rjgULzFECAeFbkvHY='
WHERE
key_id = 'cca05a4a6678e550912ca5e339712ec3eae28c5a5ccc273759c08f0d4507227d'
AND (
token = 'fQOw7O3ZuKzypvtZYoZ2E+7jL/rjgULzFECAeFbkvHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)