UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'S8uXuCJ/byfAUr1X7+yEPPGweuyecNOFhz4+oMz1aeY=' 
WHERE 
  key_id = 'ad7ff0e7d17a7071364b4b15aea3c2a73a24d6a607aa4d85ee70c101c148244c' 
  AND (
    token = 'S8uXuCJ/byfAUr1X7+yEPPGweuyecNOFhz4+oMz1aeY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029