SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = 'd31460e592853eddc1e618126714394fa8c78085d50c0278900c3e4dd8a00ac4' 
  AND token = 'lF4sD8UzM0ihsh+0cXqgJ9tu0Q/8V4QxhlhIP1beNTA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00034

JSON explain

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