SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'f863f104e3249aa97a1769f675dd48467f1860677b1eae2b2bc3fe3f6fc9087d' 
  AND token = 'dTKAcIf8iR+2U6eHjE+GHCS6O2xat/DuriBut+OX+Uo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}