UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fY0uFHFpgcuHE/54uk8XRmiOvwlVPo589p6dvuBCTJE='
WHERE
key_id = '6168868232a4cf0762d4b67c905640b8abb85e14c7a270c897dd9901056ae0de'
AND (
token = 'fY0uFHFpgcuHE/54uk8XRmiOvwlVPo589p6dvuBCTJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)