UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5CaYLFKGY+nZDYT/QASOFTuwoYsrJ4VmpZ3b3o4zJW4='
WHERE
key_id = '8acd83593f629933877ef1f9e4c001cabb33f770e1ec302018dee8677a38e622'
AND (
token = '5CaYLFKGY+nZDYT/QASOFTuwoYsrJ4VmpZ3b3o4zJW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)