UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qZ8Bl6XZqv2bx11wsO0JsDjIzqqruIXD21iG6w2WAAo='
WHERE
key_id = '5280bd2e697e158061a1efee5458ec7510e03c58152d3b46acb998b648205ef7'
AND (
token = 'qZ8Bl6XZqv2bx11wsO0JsDjIzqqruIXD21iG6w2WAAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)