UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZSfjQAPFf9DPw/iJEHAgKPCTo32EtZqiyLzPDFHOwA='
WHERE
key_id = 'c0b45d90890cdaa2c7edfa9da9bbd638c4c9d5fea36bf3be03757dc6b2fff4d2'
AND (
token = 'XZSfjQAPFf9DPw/iJEHAgKPCTo32EtZqiyLzPDFHOwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)