SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '7d6f872094f9b7d193d2ee39074b1db67af5b870d8a819805c1426853525cafe' 
  AND token = 'saJ6/zufs4c60ikJLc3s4GRIAJZa1tIke3WO6ZWTw2o=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00029

JSON explain

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