SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'ca9cf84d486e6e39c7e70dc12a9b16a970b1a0cf2ec9cc558169b5a2c93e752c' 
  AND token = 'zisvU2pLzrs7Se/nBLzIFZN5Krxj70LHwOYtEeA2aIE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00017

JSON explain

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