UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YPE2MXXraOd3IWDbPG6zQkkZTQUApX5MBQuoKe8bCgo='
WHERE
key_id = 'bc9dc0628f52bee7ad23b7d91b7e709c99ad8d15373dddbe5218d9a45d1a7f17'
AND (
token = 'YPE2MXXraOd3IWDbPG6zQkkZTQUApX5MBQuoKe8bCgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)