UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'klKdtklhj2BLInlo9UZUP1vN9dCEE4pIysmRgX5X1us='
WHERE
key_id = 'a2e3aefe7e1c3115e3e88427a0224deb7445494acda0154347b3550590799b0d'
AND (
token = 'klKdtklhj2BLInlo9UZUP1vN9dCEE4pIysmRgX5X1us='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)