UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZB9QhwsrFTiWnZcUUglA6sxgIEH/c2bML9h8LjOJ3BM='
WHERE
key_id = 'd6f04ad87f6a81417ba5bb78980df408e73b4fe26f9102d477d05a5663fc16f6'
AND (
token = 'ZB9QhwsrFTiWnZcUUglA6sxgIEH/c2bML9h8LjOJ3BM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)