SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'f10e868fdf19fd41b94d28f9a45b42d4f896957f16697b18f8fdac4b5ce66970' 
  AND token = 'gM3bxljsgAkqwRn/3gHQ2Vjdxdnn1LkHTD5LN75wlvM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00029

JSON explain

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