UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Y8CqTZUmO109xmefJdB6Kce/4NR84eXC+SzYXi5DwH8=' 
WHERE 
  key_id = '659b8a28744b3c5809cce68ec91b3bb898b4e6ea9e3b50950ea7125e2baed7bd' 
  AND (
    token = 'Y8CqTZUmO109xmefJdB6Kce/4NR84eXC+SzYXi5DwH8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020