SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '9994db81c9ca9eb49f39fde5cb58235160df8d8ec603b0ce435a5f1bfe7dc4ef' 
  AND token = 't04PdiaUbKStl+0NkWvnzKymaVl6U5wxXY2kgoVLvLE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

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