SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '42f31dcd032340e5e13e0d5fb2a12f0dcfd2896f32a1e57b2936d7ad167e81e8' 
  AND token = 'qEreJaDI8HN6H9GmLCkexibY2bie7cfTyWz/QPB8ooU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00021

JSON explain

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