UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FHtsxnr+cEDQZG5Y2RfKy0qw0XYFIUPPucAQka2nr/4='
WHERE
key_id = 'bc72dd9166a4f3aae6265ca339a830fe74c98775b4871784275d0394300a6697'
AND (
token = 'FHtsxnr+cEDQZG5Y2RfKy0qw0XYFIUPPucAQka2nr/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)