UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gRQsDRwGBaWf+jpb6JZ6pvCBujuczgA45t20ah3lfVE='
WHERE
key_id = '40bbe5fd2e2cb7d772f8159a65533cbc8fe367cefb0820de7e140a21c907744a'
AND (
token = 'gRQsDRwGBaWf+jpb6JZ6pvCBujuczgA45t20ah3lfVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)