UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HTFJ+R871ts+0kuabmfZPCISQ/mJgOB/jKhun3HHezE='
WHERE
key_id = 'b5e6f780fc5229015fe0916db78ea1b4fdb33c38638a75138623e1e28a22a9ef'
AND (
token = 'HTFJ+R871ts+0kuabmfZPCISQ/mJgOB/jKhun3HHezE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)