SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'd1dad4c01539de6cfe9609d5624eb7151d8a5127fc61a0e340d3932703f27268' 
  AND token = 'mBLKGTx1qQ544bt2uM9dgpnz7a6XcPLO9GfjSclHT84=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00028

JSON explain

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