UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'N0bhDEqZ+U9BYI3dQ+/K3GlQ3yT0aLwquIGSTOPVaTg=' 
WHERE 
  key_id = 'bfda7aac7926cd8e1f3267eb22a76cbacf5bf5fa6273d46438f902fc415062e0' 
  AND (
    token = 'N0bhDEqZ+U9BYI3dQ+/K3GlQ3yT0aLwquIGSTOPVaTg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047