SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '5c80d08b8d29221bb43b7ed788c3afe8c19c8b3b85ffa0321d8b2ddbe7723811' 
  AND token = 'QmTLydFz+Lb63JnySLVyMEH4ZWJ6HhbI31yODKpD59k=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00034

JSON explain

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