UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Z9kVah+DHgRq2nrlABvJSOB2HJzh1vcgznO/XVa8wRI=' 
WHERE 
  key_id = 'f1986ec3a61b8e55378d0c9b82e3be8dd34e51c30303e851796bd4546d4397f7' 
  AND (
    token = 'Z9kVah+DHgRq2nrlABvJSOB2HJzh1vcgznO/XVa8wRI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036