UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '92ihRVdSH90EZyDG9UVCxyJSrvZFY17hlt5e2QNvw5o='
WHERE
key_id = 'd8d45ee971777fdc8a277ac2c3b2b4ddf344ce29efcd6cd82eb2e1dc77a979e2'
AND (
token = '92ihRVdSH90EZyDG9UVCxyJSrvZFY17hlt5e2QNvw5o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)