UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BdFAnKVZ3l0j2c+nqVjNLIHDe/GkdyPlCoifIWa4DXw='
WHERE
key_id = 'a725b6d363a745e379e87dcc4edd5e2de9c1e972e8925625c5e17e9c54c8ed84'
AND (
token = 'BdFAnKVZ3l0j2c+nqVjNLIHDe/GkdyPlCoifIWa4DXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)