SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = 'bbfeba6ae7f4ac891c2d4514b6d105e696a81506649bd05d56d37f541d3d3376' 
  AND token = 'vZGOKvSejyUCB9aVa1nDcQR9j6RKY/FG3TtKcOGnI/U=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00034

JSON explain

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