SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'e0bdd0fcfa52b783a6a59b0ac4cb64e4860b0b1771bff4a2e8332548dadad429' 
  AND token = 'lcm/jV3dBYwvez9cbQjSqD8fD8KN7MlKtq1b0sW3KAo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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