UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+6KaixZmu9wafXlES3Vk4jlyiryFx0xh32XFu/99v+U='
WHERE
key_id = 'b17c407bb92a79b741092c9964f8f76d7bb820e04da928f6e51de00a922c798b'
AND (
token = '+6KaixZmu9wafXlES3Vk4jlyiryFx0xh32XFu/99v+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)